package cn.ljy.uem.dao;

import cn.ljy.authority.dao.BaseMapper;
import cn.ljy.uem.model.SchoolPosition;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 学校职务的数据层操作类
 *
 * @author 凡渊
 * @date 2022/07/18 10:43:23
 */
@Mapper
public interface SchoolPositionMapper extends BaseMapper<SchoolPosition> {
    /**
     * 王秋林 2022-12-19
     *查找教师相关联的职务name以便展示excel下拉框
     * @return {@link List}<{@link String}>
     */
    @Select("select name from school_position order by sort asc")
    List<String>  getPositionNames();
}
